/**
 *Copyright (c) 2024 watereyes
 * safetymanagement is licensed under Mulan PubL v2.
 * You can use this software according to the terms and conditions of the Mulan
 * PubL v2.
 * You may obtain a copy of Mulan PubL v2 at:
 *          http://license.coscl.org.cn/MulanPubL-2.0
 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND,
 * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT,
 * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE.
 * See the Mulan PubL v2 for more details.
 */
package com.koron.personal.mapper;

import com.koron.personal.domain.UserWorkbench;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;


public interface UserWorkbenchMapper {

    @Delete("delete from user_workbench where user_code = #{userCode}")
    void delete(@Param("userCode") String userCode);

    @Insert("<script>" +
            "insert into user_workbench(id,add_time,user_code,user_name,code,name,url) VALUES" +
            "<foreach collection='userWorkbenchList' item='bean' separator =','>" +
            "(#{bean.id},#{bean.addTime},#{bean.userCode},#{bean.userName},#{bean.code},#{bean.name},#{bean.url})" +
            "</foreach>"
            + "</script>")
    void insert(@Param("userWorkbenchList")List<UserWorkbench> userWorkbenchList);

    @Select("select * from user_workbench where user_code = #{userCode}")
    List<UserWorkbench> list(@Param("userCode")String userCode);
}
